package com.service;

import com.bean.Room;

import java.sql.SQLException;
import java.util.List;
import java.util.Map;

public interface RoomService {


     List<Room> selectAll() throws SQLException ;

     boolean deleteById(Integer id) throws SQLException ;


     boolean removeAll(String[] idsArr) throws SQLException ;

     boolean insert(Room r) throws SQLException ;

     boolean update(Room r) throws SQLException;


     Integer count() throws SQLException ;


     Integer countSearch(String search) throws SQLException ;

     Integer countSearch(Map<String,String> map) throws SQLException ;

     List<Room> selectAllPagination(Integer offset, Integer limit) throws SQLException ;

     List<Room> selectAllPaginationSearch(Integer offset, Integer limit, String search) throws SQLException ;

     List<Room> selectAllPaginationSearch(Integer offset, Integer limit, Map map) throws SQLException ;
}
